﻿

create proc dbo.GetTitel
@TitelKey	int = null
as
begin
	set nocount on

	select	t.TitelKey,
			t.TitelBez
	from	dbo.Titel t
	where	t.TitelKey = @TitelKey
				or @TitelKey is null

end
GO
GRANT EXECUTE
    ON OBJECT::[dbo].[GetTitel] TO PUBLIC
    AS [dbo];

